﻿CREATE VIEW [dbo].[admin_UserAccessApplication]
AS
SELECT     dbo.aspnet_Applications.IDIntern, dbo.aspnet_Users.UserId, dbo.aspnet_Applications.MenuName, dbo.aspnet_Applications.ApplicationId
FROM         dbo.admin_RoleInApplications INNER JOIN
                      dbo.aspnet_Applications ON dbo.admin_RoleInApplications.ApplicationId = dbo.aspnet_Applications.ApplicationId INNER JOIN
                      dbo.aspnet_UsersInRoles ON dbo.admin_RoleInApplications.RoleId = dbo.aspnet_UsersInRoles.RoleId INNER JOIN
                      dbo.aspnet_Users ON dbo.aspnet_UsersInRoles.UserId = dbo.aspnet_Users.UserId